SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].gspOrder_UPDATE
(
@orderId int = null,
@customerId int = null,
@productId int = null,
@createdDate datetime = null,
@lastModifiedDate datetime = null,
@commitDate datetime = null,
@sendDate datetime = null,
@isDeleted bit = null,
@isCommited bit = null
)
AS

UPDATE
  [dbo].[Order]
SET
  [CustomerId] = @customerId,
  [ProductId] = @productId,
  [CreatedDate] = @createdDate,
  [LastModifiedDate] = @lastModifiedDate,
  [CommitDate] = @commitDate,
  [SendDate] = @sendDate,
  [IsDeleted] = @isDeleted,
  [IsCommited] = @isCommited
WHERE
  [OrderId] = @orderId


GO
